Download Oracle Database 12c: Installation and Administration.1z0-062.PracticeTest.2018-10-10.215q.vcex

Vendor: Oracle
Exam Code: 1z0-062
Exam Name: Oracle Database 12c: Installation and Administration
Date: Oct 10, 2018
File Size: 2 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled. 
  
You want to perform online segment shrink to reclaim fragmented free space below the high water mark. 
What should you ensure before the start of the operation?
  1. Row movement is enabled.
  2. Referential integrity constraints for the table are disabled.
  3. No queries are running on this table.
  4. Extra disk space equivalent to the size of the segment is available in the tablespace.
  5. No pending transaction exists on the table.
Correct answer: A
Question 2
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?
  1. shutting down the database instance that is being upgraded
  2. executing the catctl.pl script to run the upgrade processes in parallel
  3. running the Pre-Upgrade Information Tool
  4. copying the listener.ora file to the new ORACLE_HOME
Correct answer: C
Explanation:
References:http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12395
References:
http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12395
Question 3
Your database is open and the listener LISTENER is up. You issue the command:
LSNRCTL> RELOAD 
What is the effect of reload on sessions that were originally established by listener?
  1. Only sessions based on static listener registrations are disconnected.
  2. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.
  3. The sessions are not affected and continue to function normally.
  4. All the sessions are terminated and active transactions are rolled back.
Correct answer: C
Question 4
Which statement is true regarding the startup of a database instance?
  1. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option.
  2. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.
  3. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the immediate option or the abort option.
  4. Media recovery is required when the database is shut down by using either the immediate option or the abort option.
  5. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.
Correct answer: E
Explanation:
References:http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm
References:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm
Question 5
Examine the memory-related parameters set in the SPFILE of an Oracle database:
  
Which statement is true?
  1. Only SGA components are sized automatically.
  2. Memory is dynamically re-allocated between the SGA and PGA as needed.
  3. The size of the PGA cannot grow automatically beyond 500 MB.
  4. The value of the MEMORY_TARGET parameter cannot be changed dynamically.
Correct answer: B
Question 6
Which two statements are true about extents? (Choose two.)
  1. Blocks belonging to an extent can be spread across multiple data files.
  2. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
  3. The blocks of a newly allocated extent, although free, may have been used before.
  4. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.
Correct answer: BC
Question 7
You execute the commands:
  
Which two statements are true? (Choose two.)
  1. The create user command fails if any role with the name Sidney exists in the database.
  2. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.
  3. The user Sidney is created but cannot connect to the database instance because no profile is default.
  4. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.
  5. The user Sidney is created and authenticated by the operating system.
Correct answer: AD
Explanation:
References:
References:
Question 8
Examine the query and its output:
  
What might have caused three of the alerts to disappear?
  1. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
  2. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
  3. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.
  4. The database instance was restarted before the execution of the second query.
Correct answer: D
Question 9
Which two statements are true? (Choose two.)
  1. A role cannot be assigned external authentication.
  2. A role can be granted to other roles.
  3. A role can contain both system and object privileges.
  4. The predefined resource role includes the unlimited_tablespace privilege.
  5. All roles are owned by the sys user.
  6. The predefined connect role is always automatically granted to all new users at the time of their creation.
Correct answer: BC
Explanation:
References:
References:
Question 10
Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).
  1. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
  2. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
  3. Use the DBMS_PDB package to clone an existing PDB.
  4. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
  5. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.
Correct answer: ACD
Explanation:
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks:* (A) Create a PDB by using the seed as a template Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB. * (C) Create a PDB by cloning an existing PDB Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB. The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files. * Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). 
This statement enables you to perform the following tasks:
* (A) Create a PDB by using the seed as a template 
Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB. 
* (C) Create a PDB by cloning an existing PDB 
Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB. 
The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files. 
* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB 
Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!